﻿

SET IDENTITY_INSERT [dbo].[Roles] ON
INSERT INTO [dbo].[Roles] ([RoleId], [RoleName]) VALUES (1, N'管理员')
INSERT INTO [dbo].[Roles] ([RoleId], [RoleName]) VALUES (2, N'科室领导')
SET IDENTITY_INSERT [dbo].[Roles] OFF

SET IDENTITY_INSERT [dbo].[VoteConfigs] ON
INSERT INTO [dbo].[VoteConfigs] ([Id], [Count], [StartTime1], [EndTime1], [StartTime2], [EndTime2], [StartTime3], [EndTime3], [Active]) VALUES (1, 1, N'2017-01-02 20:00:00', N'2017-01-02 20:30:00', N'2017-01-02 20:30:00', N'2017-01-02 21:30:00', N'2017-01-02 21:30:00', N'2017-01-02 21:50:00', 1)
SET IDENTITY_INSERT [dbo].[VoteConfigs] OFF



SET IDENTITY_INSERT [dbo].[UserInfo] ON
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (1, N'admin', N'管理员', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 1, N'秘书处')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (2, N'办公室', N'办公室领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'办公室')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (3, N'计财科', N'计财科领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'计财科')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (4, N'装备管理科', N'装备管理科领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'装备管理科')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (5, N'教育技术科', N'教育技术科领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'教育技术科')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (6, N'信息中心', N'信息中心领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'信息中心')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (7, N'统计中心', N'统计中心领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'统计中心')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (8, N'研培中心', N'研培中心领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'研培中心')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (9, N'资产管理中心', N'资产管理中心领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'资产管理中心')
INSERT INTO [dbo].[UserInfo] ([UserId], [UserName], [DisplayName], [Password], [LastLoginIPAdress], [LastLoginDate], [IsLock], [RoleId], [DeptName]) VALUES (10, N'教育资助中心', N'教育资助中心领导', N'366011E52DFE7A5252D6C877B21B45', NULL, NULL, 0, 2, N'教育资助中心')


SET IDENTITY_INSERT [dbo].[UserInfo] OFF

INSERT INTO SysConfigs (ImportPosition) VALUES (0);